Jon Mark H
Jon Mark H
Reactions
-
Re: Import an Excel file into exisiting Smartsheet
Hey @Lara Lehnerz ! There are (2) potential solutions: #1 - if it's not a huge amount of data, I would just copy & paste it into the Smartsheet. #2 - if that's not working do the following: A) Im…1 · -
Re: Combination of PARENT and LEFT function
Hey @Emily NZ I may be mistaken, as I'm not sure on how the formulas for NZ may differ from the USA - but I believe your formula should just be: =LEFT(PARENT([Primary Column]@row), 6) (i.e. no "…1 · -
Re: Hi all,
Hey Keval - Unfortunately there is not currently a way, strictly in Smartsheet to do this automatically - You would have to go in and manually export to PDF or generate a document with each row. You …1 · -
Re: Can I pull data from different columns and deposit them each into a specific cell?
If I'm understanding correctly - I would suggest using a helper column in the sign in page - which will join the Class & date attended. Something like this: ="Course: " + Class@row + &q…1 · -
Re: COUNTIF with multiple criterias
Hey Blue - You're close! COUNTIF only takes (1) range & (1) criterion - Looks like you need a COUNTIFS instead: =COUNTIFS([Were all attendees in the meeting room on time?]:[Were all attendees in …1 ·
